--***********************************************************
--SEARCH Stored Procedure for <Table> table
--***********************************************************
GO

USE <Database>
GO

IF EXISTS (SELECT sys.objects.name FROM sys.objects INNER JOIN sys.schemas ON sys.objects.schema_id = sys.schemas.schema_id WHERE sys.objects.name = '<TableU>Search'  and sys.schemas.name = '<Owner>'  and sys.objects.type = 'P') 
DROP PROCEDURE [<Owner>].[<TableU>Search] 
GO

CREATE PROCEDURE [<Owner>].[<TableU>Search] 
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      @<RDisplayField><MiscTag> <SQLType>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,@<RDisplayField><MiscTag> <SQLType>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      @<RDisplayField> <SQLType>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,@<RDisplayField> <SQLType>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      @<Field> <SQLType>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,@<Field> <SQLType>
</If Loop>
     ,@SearchCondition nchar(25)
AS
BEGIN

IF @SearchCondition = 'Contains'
BEGIN

SELECT 
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE '%' + LTRIM(RTRIM(@<Field>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE '%' + LTRIM(RTRIM(@<Field>)) + '%')
</If Loop>

END


IF @SearchCondition = 'Equals'
BEGIN

SELECT 
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] = LTRIM(RTRIM(@<Field>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] = LTRIM(RTRIM(@<Field>)))
</If Loop>

END


IF @SearchCondition = 'Starts with...'
BEGIN

SELECT
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE LTRIM(RTRIM(@<Field>)) + '%')
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE LTRIM(RTRIM(@<Field>)) + '%')
</If Loop>

END


IF @SearchCondition = 'More than...'
BEGIN

SELECT
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] > LTRIM(RTRIM(@<Field>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] > LTRIM(RTRIM(@<Field>)))
</If Loop>

END


IF @SearchCondition = 'Less than...'
BEGIN

SELECT
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] < LTRIM(RTRIM(@<Field>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] < LTRIM(RTRIM(@<Field>)))
</If Loop>

END


IF @SearchCondition = 'Equal or more than...'
BEGIN

SELECT
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] >= LTRIM(RTRIM(@<Field>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] >= LTRIM(RTRIM(@<Field>)))
</If Loop>


END


IF @SearchCondition = 'Equal or less than...'
BEGIN

SELECT
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField><MiscTag>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] <= LTRIM(RTRIM(@<Field>)))
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] <= LTRIM(RTRIM(@<Field>)))
</If Loop>

END

END
GO

GRANT EXECUTE ON [<Owner>].[<TableU>Search] TO [Public]
GO

